<CFQUERY datasource="#application.dsn#" name="getusers">
SELECT * FROM users
</CFQUERY>
[<A href="users_frmaddedit.cfm">Add</A>]
<TABLE border="1" cellspacing="1" cellpadding="1" align="center" width="95%">

	<TR>
		<TD>username</TD>
		<TD>password</TD>
		<TD>name</TD>
		<TD>email</TD>
		<TD>Edit/Delete</TD>
	</TR>
	
	<CFOUTPUT>
	<CFLOOP query="getusers">
	<TR>

<TD>#username#</TD>
<TD>#password#</TD>
<TD>#name#</TD>
<TD>#email#</TD>

	<TD>[<A href="users_frmaddedit.cfm?userid=#userid#">Edit</A>]&nbsp;[<A href="users_frmdelete.cfm?userid=#userid#">Delete</A>]</TD>
	</TR>
	</CFLOOP>
	</CFOUTPUT>
</TABLE>
